setting
Table: setting
The setting table stores configurable system-level parameters used to control application behavior.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| settingId | smallint(6) | NO (PK) | Unique identifier for each setting |
| createdDate | datetime | YES | Date and time when the setting was created |
| description | varchar(255) | YES | Description explaining the purpose of the setting |
| lastEditedDate | datetime | YES | Date and time when the setting was last modified |
| name | varchar(255) | NO (UNIQUE) | Unique key name used to reference the setting |
| value | varchar(255) | YES | Value assigned to the setting |
| createdByUserId | int(11) | YES | User who created the setting |
| lastEditedByUserId | int(11) | YES | User who last modified the setting |
| displayName | varchar(45) | YES | Human-readable name displayed in the UI |
Indexes
- PRIMARY KEY — Index on
settingId - UNIQUE KEY — Index on
name - CreatorUserIdFK — Index on
createdByUserId - EditorUserIdFK — Index on
lastEditedByUserId
Foreign Key Relations
createdByUserId→ user.mappedIdlastEditedByUserId→ user.mappedId
Usage Notes
- Used to manage application configuration without code changes.
- Settings can control feature flags, thresholds, and runtime behavior.
- The unique
namefield allows settings to be retrieved programmatically. - Audit fields help track who created or modified each configuration entry.